General Ledger Export

Navigate: ClosedTax > Tax Accounting > General Ledger Export

Description

Create a file of General Ledger transactions. You can then export the file can from Aumentum to a third party General Ledger accounting system. You can set the export as a recurring, automated process. Later, you can import the related information. The system checks for missing mappings and generates an error report if any mappings are missing. The system also produces a report showing all created transactions.

A report is automatically produced and is sorted by fund and account. The transaction type is also displayed. if general ledger entries are created at the receipt detail level, paid by whom information is also generated in the GL Export.

  1. Export a General Ledger File - Create and export a file of General Ledger transactions. You can then export the file from Aumentum to another software application, such as a General Ledger accounting system.

  2. Recurring Exports of General Ledger Transactions - Set the export to  automatically run as a batch process.

California

  • The General Ledger (G/L) Export process accepts negative balance transactions. Negative agency balances are tracked in Distribution to produce General Ledger entries when the negative agency balance:

    • Is incurred.

    • Increases or decreases.

The Distribution Negative Agency Balance Detail Report shows amounts held in negative agency balances for the purpose of reconciling with the jurisdiction G/L balances for negative agency amounts. You can define whether to run the report by distribution date or by business date ranges with the option to select one or multiple agencies.

Dependencies, Prerequisites, and Setup

Tax Accounting

  • A general ledger export file must exist before you can recreate an export file.

  • You must have exported a general ledger file before you can print a financial detail transaction listing.

  • File Input/Output - To include the effective pay date in the General Ledger Export file, you must set up the File I/O to include the effective pay date in the export file layout. Also, you must set the application setting General Ledger Summary Level to Business Date – Eff Pay Date, Roll Type.

  • General Ledger Mappings - Set up mappings.

  • Maintain Tax Accounting Settings - You must have the tax accounting setting General ledger summary level set up before you can export a general ledger file.

Tax Accounting Settings

  • Set any Tax Accounting settings via Tax > Tax Accounting > Setup as applicable to the export.

Accounts Receivable/Cashiering/ Distribution Modules

  • A charge, payment, or distribution must exist.

Configuration Menu

  • Manage Input/Output File Configuration - Create the export file layout.

Tips

Select Manage Export Files from Common Actions to display previously exported files and to view, edit, and delete the files.

This task can be run for any date range or a specific transaction type (charge, payment, or distribution). You have the option to print the report without creating the file